2015-07-01 - 16728 - Rel Notes - .Net App to upload work order confirmations #SAPReleaseNotes

Release Notes - Final

16728 : SNC - .Net App to generate a file to upload confirmations.

Admin Info

Purpose	.Net App for Generating a file for work order confirmations
Release No	001
Submitted on	07/01/2015
Submitted by	Adithya
Environment	DEV to QAS
Sent To	Jeffrey Mau, JIngsha
Object(s) created by	Vamshi, Venkat
Object(s) tested by	Adithya
Transport Status	Transports are there in SND 100

Transport and Technical Objects

Sl.	Transport ID	Description	Object Name
1	SNDK900446	SNC:16728 - Add Link to .Net Work order process	/SCF/UNAVCFG
2	SNDK900444	SNC:16728 - Work Order File Download and .Net Link	ZGET_SELECTION_POST ZNEC_PRE_MENU_ITM_CLICK ZNEE_EN008_IE_WODWLD_1 ZWO_PO_LINE

Release Notes

For Infrastructure

For Requester

The .Net application shows the data only which is sent to it in the downloaded file from the download center.
Once the "Day END Process" is hit in the .Net application there must not be any changes done on the confirmed work orders.
The .Net link shall be manually placed in the table "ZNEC_CRYSTL_PATH" in each client, vendor number will be dynamically picked from the log in user ID.

Test Notes

SND100 & SNQ100

	.Net Application functionality testing Individually
Test ID	Test Scenario	Expected Results	Actual Results	P/F	Documents	Notes	Tested	QA By
SCM1	Full End to End Cycle with combination of two vendors.	End to End - Download & Upload must be done correctly.	End to End - Download & Upload is processed successfully with confirmations updated CUT, EMB & SEW	P	Download files Sent to .Net: 202663: CUST_NEC_WOACT_20150701093107.csv 202666: CUST_NEC_WOACT_20150701093123.csv Received Files (updated with confirmations) 202663: CUST_NEC_WOACT_CONFIRMATION_20157120345.csv 202666: CUST_NEC_WOACT_CONFIRMATION_20157120289.csv	END to END is done with Pos 4500075379, 4500075373, 4500075369 4500075365 4500075383	Adithya	Adithya
SCM2	Download all upload only changed work orders	The File which generated for uploading confirmations must have the WOs which are updated with the confirmations. On Uploading the file the confirmations must be updated.	The File generated from .Net app is generated with changed work orders and after uploading it in Upload Center the confirmations have been updated successfully for those Work orders for which confirmations is updated. rest of the Work orders are not effected.	P	4500075379 4500075373 4500075369 Updated Work orders for Po's 4600008425, 4600008427, 4600008428 - File has is received with these Po's In DEV seen that Work order count is 104.080 before download and after upload.		Adithya	Adithya
SCM3	Download the Wo with CNCL status and upload it and see if other work orders are updated with the status	The work orders other than the CNCL must be updated with confirmations	The work orders other than the CNCL are updated with confirmations		The File which is uploaded is ended with errors but the other work orders which are not with the CNCL status are updated with respective confirmations		Adithya	Adithya
SCM4	Validate if the ML Work orders are seen in EB (Update EB Wo from ML app screen)	No EB POs Work Orders shall be seen in the ML Screen and vice versa	EB Work Orders are not seen in ML Application	P	EB PO is not shown up in ML Screen - 4500075379		Adithya	Adithya
SCM5	Upload the file which has transport phase updated already but no COM status.	COM Shall be updated though Transport is updated with out deleting the existing updated in TRANSPORT	COM status is updated correctly with the upload file though TRANSPORT is already updated.	P	4500075350 File Sent: CUST_NEC_WOACT_20150701123534.csv File Received: CUST_NEC_WOACT_CONFIRMATION_20157122100.csv.		Adithya	Adithya
SCM6	Once the download is clicked - no changes shall be allowed	No Changes shall be allowed after Download is clicked from .Net Application
	Download file Testing
SCM7	If any one line (WO) of a PO is active ( not updated with COM)	All the work orders of that PO are to be downloaded in the file			CUST_NEC_WOACT_CONFIRMATION_201571084225.csv
SCM8	If any Work orders of the PO are not even updated with any one phase	All the work orders must be downloaded in the file	All work orders are downloaded in the file	P	4600008588 4600008587		Adithya	Adithya
SCM9	If all work orders of the PO are updated with COM	No work orders of the PO must be downloaded in the file	No work orders are downloaded in the file	P	4600008594		Adithya	Adithya
SCM10	If Work orders of the PO lines are mix of Open, Closed & Complete	All the work orders must be downloaded in the file	All work orders are downloaded in the file	P	4600008590		Adithya	Adithya
SCM11	If the work orders of the PO are mixed with One WO not updated any phase, Two Work Orders updated with all phases & One Work Order updated with 2 phases	All the work orders must be downloaded in the file	All work orders are downloaded in the file	P	4600008591		Adithya	Adithya
SCM12	Download the file wide open	All the Open POs and its corresponding Work orders must be downloaded in the file	All the Open POs and its corresponding Work orders are downloaded in the file	P			Adithya	Adithya
	.Net Application Screen testing
SCM13	Un Check functionality	We should be able to uncheck the confirmation flag	We were able to uncheck the confirmation flag	P			Adithya	Vamshi
SCM14	On hitting Day End process	A file will be generated/downloaded with the work orders for which the confirmations are updated.	A file is generated/downloaded with the work orders for which the confirmations are updated.	P			Adithya	Vamshi
	.Net Application Link testing
SCM15	If we hit Simple WO List under Reports	.Net application page shall be opened with the vendor which a user is logged in	.Net application page is opened with the vendor which a user is logged in	P			Adithya	Adithya
	File2 to .Net Application
SCM16	Execute the Program ZWO_PO_LINE Wide Open	A file must be generated with all the work orders of all the vendors and placed in the defined path of the application server AL11 in SND	A file is generated with all the work orders of all the vendors and placed in the defined path of the application server AL11 in SND	P			Adithya	Adithya

SNQ100

Test ID	Test Scenario	Expected Results	Actual Results	P/F	Documents	Notes	Tested by	QA by
SCM1	Full End to End Cycle with combination of two vendors.	End to End - Download & Upload must be done correctly.Validation Reports- Both CSV files created from SNC (WOs & POs) should contain ALL records per filter criteria (all WOs for open POs) Records loaded in .NET should contain ALL records received from SNC Confirmations in .NET should be reflected in SNC WO list. Confirmations in .NET should be reflected in ECC (via idoc)	End to End - Download & Upload are done. The files which are generated from Download center and ZWO_PO_LINE are as per the record. Validated the records which are sent from the SNC Download Job and .Net Application are same in count. Updated confirmations from .Net screen and uploaded the file in the Upload Center of SNC UI and checked the confirmations in Work Order Work list screen. Confirmations are been updated in the ECC with ORDRSP IDOC.	P	1. a) POs which are Complete are not downloaded in the download file 4500073821, 4500073849, 4500073851. b) Mix of complete and Inprocess lines of a PO 4500073850 2) Count from the upload file: 202663: Total Records: 36948, Purchase Orders: 183 Work Orders: 1420 202666; Total Records: 62476, Purchase Orders: 594 Work Orders: 2840 3. Update CUT & EMB for POs 202663: 4500075520, 4500075407 202666: 4500074877 4500074878 4. Update CUT & EMB for POs 202663: 4500075520, 4500075407 202666: 4500074877 4500074878	Downloaded file from Download Center Vendor: 202663 cust_nec_woact_20150717092232.csv Vendor 202666cust_nec_woact_20150717092511.csv Day End Process file from the .Net Application. Vendor 202663 CUST_NEC_WOACT_CONFIRMATION_2015717121016.csv Vendor 202666 CUST_NEC_WOACT_CONFIRMATION_2015717124344.csv	Adithya	Venkat
SCM2	Execute scenarios with multiple upload/download cycles to ensure Work Orders statuses are updated correctly in SNC after each receipt from .NET	WO confirmations in SNC after each cycle should be correct. ECC idoc confirmations should be correct	WO confirmations in SNC after each cycle are correct. ECC idoc confirmations are correct			First uploaded file from the .Net application: CUST_NEC_WOACT_CONFIRMATION_2015717151417.csv updated few more work orders and Re hit Day End Process: CUST_NEC_WOACT_CONFIRMATION_2015717151417.csv
SCM3	Download all upload only changed work orders	The File which generated for uploading confirmations must have the WOs which are updated with the confirmations. On Uploading the file the confirmations must be updated.	The File which generated for uploading confirmations are having only the WOs which are updated with the confirmations. On Uploading the file the confirmations must be updated.	P	The data which is modified are only triggered in the Day End process file from .Net application, the rest of the work orders are unchanged in the SNC.	Above uploaded Files can be taken as the examples.	Adithya	Venkat
SCM4	Download the Wo with CNCL status and upload it and see if other work orders are updated with the status	The work orders other than the CNCL must be updated with confirmations	The Work orders other than the CNCL status are updated with the confirmations and the WO with CNCL are not updated and set an Error message.	P	Attached is the file "Day End Process" with the confirmations updated. CUST_NEC_WOACT_CONFIRMATION_2015717144253.csv Attached is the list of work orders updated when a Work Order is with CNCL is updated export_20150717145238.xls	PO: 4500075495 Work Orders; W300003368 & W300003369	Adithya	Venkat
SCM5	Security check- User will try to enter PO which may or may not be part of their company	No EB POs Work Orders shall be seen in the ML Screen and vice versa	No EB POs Work Orders are seen in the ML Screen and vice versa	P	PO 4500075493 is not shown in 202663 URL and 4500075487 is not shown up in the 202666 URL.		Adithya	Venkat
SCM6	Upload the file which has transport phase updated already but no COM status.	COM Shall be updated though Transport phase is updated with out deleting the existing updated in TRANSPORT	COM phase is updated though Transport phase is updated with out deleting the existing updated in TRANSPORT	P	PO 4500075518, ASN is Published and Transport phase is updated for all the Work Orders of the PO. Updated COM from the .Net application and COM status is updated in the corresponding Work Orders of the PO.		Adithya	Venkat
SCM7	Load Testing Upload Confirmations to Find Time	The phases updated from the .Net Application are to be updated with the upload of the Day end process file in upload center of SNC.	The phases updated from the .Net Application are updated with the upload of the Day end process file in upload center of SNC.	P	Uploaded 1114 Work orders and it took 25 mins in SNC	Here is the file attached which is uploaded CUST_NEC_WOACT_CONFIRMATION_201572013267.csv

.Net Application testing.

Test ID	Test Scenario	Expected Results	Actual Results	P/F	Documents	Notes	Tested by	QA by
001	Enter PO number and click on Apply	The work order details for the PO will be displayed in the grid	The work order details for the PO are displayed in the grid	P			Vamshi/ Adithya	Venkat
002	Update the confirmations for the Phases by check and unchecking the check boxes and save	User should be able to check and uncheck the check boxes for the phase completed and the data should be saved to database on Save click	Check and Un Check functionality is working and the data is saved after SAVE button is hit.	P			Vamshi/ Adithya	Venkat
003	Day End Process	User should be able to download the updated confirmations.	When Hit "Day end Process" the file is downloaded from application with the updated POs	P			Vamshi/ Adithya	Venkat
004	Ensure all Open PO Lines Received	All Open POs shall be received in the downloaded file and in to the .Net application	All Open POs are received in the downloaded file and in to the .Net application	P			Vamshi/ Adithya	Venkat

Download file Testing

Test ID	Test Scenario	Expected Results	Actual Results	P/F	Documents	Notes	Tested by	QA by
DC001	Run the Download file Job 1. If any one line (WO) of a PO is active ( not updated with COM) 2. If No Work orders are updated with any phase of the PO. 3. If all work orders of the PO are updated with all Phases till COM 4. If Work orders of the PO lines are mix of Open, Closed & Complete	A file shall be placed in the application server. 1. All the work orders of that PO must be downloaded in the file. 2. All the work orders of that PO must be downloaded in the file. 3. No Work orders of that PO must be downloaded in the file. 4. All the work orders of that PO must be downloaded in the file.	Files are placed in the application server. 1. All the work orders of that PO are in downloaded in the file. 2. All the work orders of that PO are downloaded in the file. 3. No Work orders of that PO are downloaded in the file. 4. All the work orders of that PO are downloaded in the file.	P	1. 4500074459 2. 4500074451 3. 4500075074 . 4. 4500075485	Master list is a list which is having the list of all Open & Closed POs. MasterList_QAS.xls Downloaded file from SNC: 202663 cust_nec_woact_20150714122741.csv 202666 cust_nec_woact_20150714122129.csv	Adithya	Venkat
DC002	Download the file wide open	All the Open POs and its corresponding Work orders must be downloaded in the file	All the Open POs and its corresponding Work orders are downloaded in the file	P		Consider the above uploaded file.	Adithya	Venkat